전처리 데이터¶

df = pd.read_csv('C:\jupyter_notebook_file\병합DB_2차.csv')
df

교량별 시계열 데이터¶

Separation of data for training and testing

# train, test 데이터 시각화
for i in range(len(df_list)):
    ax = train_list[i].plot()
    test_list[i].plot(ax=ax)
    plt.title(i)
    plt.legend(['train', 'test'])
    plt.show()

예측 결과 scatter¶

#------------------------------------------------------------------------------------------#
# 예측 결과 시각화하여 확인
# 원래 값과 예측 값이 일치하면 직선에 가깝게 분포
for i in range(len(df_list)):
    plt.scatter(y_test[i], y_pred[i])
    plt.xlabel("WL Index: $Y_i$")
    plt.ylabel("Predicted WL Index: $\hat{Y}_i$")
    plt.title(str(i)+"번째: WL vs Predicted WL Index: $Y_i$ vs $\hat{Y}_i$")
    plt.show()

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral
Font 'default' does not have a glyph for '\ubc88' [U+bc88], substituting with a dummy symbol.
Substituting symbol 번 from STIXGeneral
Font 'default' does not have a glyph for '\uc9f8' [U+c9f8], substituting with a dummy symbol.
Substituting symbol 째 from STIXGeneral

교량별 LSTM 모델의 예측 그래프¶

for i in range(len(df_list)):
    plt.figure(figsize=(16,8))
    plt.title(i)
    plt.plot(a_axis[i], y_train_np[i].reshape(X_train_t[i].shape[0],), 'o-')
    plt.plot(b_axis[i], y_pred[i].reshape(X_test_t[i].shape[0],), 'o-', color='red', label='Predicted')
    plt.plot(b_axis[i], y_test_np[i].reshape(X_test_t[i].shape[0],), 'o-', color='green', alpha=0.2, label='Actual')
    plt.legend()
    plt.show()

	Unnamed: 0	bridge_name	address	etc_address	latitude	longitude	brid_height_origin	location_start	wl_station_code	station_name	location	obs_date	WL	bridge_height
0	0	한평교	경기도	안성시	37.106555	127.433259	6.1	[37.106555, 127.433259]	1007604	안성시(한평교)	[37.10666666666667, 127.43361111111112]	2016-11-09 01:00:00	145.0	734.0
1	1	한평교	경기도	안성시	37.106555	127.433259	6.1	[37.106555, 127.433259]	1007604	안성시(한평교)	[37.10666666666667, 127.43361111111112]	2016-11-09 02:00:00	145.0	734.0
2	2	한평교	경기도	안성시	37.106555	127.433259	6.1	[37.106555, 127.433259]	1007604	안성시(한평교)	[37.10666666666667, 127.43361111111112]	2016-11-09 03:00:00	145.0	734.0
3	3	한평교	경기도	안성시	37.106555	127.433259	6.1	[37.106555, 127.433259]	1007604	안성시(한평교)	[37.10666666666667, 127.43361111111112]	2016-11-09 04:00:00	146.0	734.0
4	4	한평교	경기도	안성시	37.106555	127.433259	6.1	[37.106555, 127.433259]	1007604	안성시(한평교)	[37.10666666666667, 127.43361111111112]	2016-11-09 05:00:00	146.0	734.0
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
7456997	7456997	굴포천교	인천광역시	계양구	37.580726	126.776421	10.0	[37.580726, 126.776421]	1019653	벌말교	[37.583333333333336, 126.77222222222223]	2020-08-26 22:00:00	238.0	1239.0
7456998	7456998	굴포천교	인천광역시	계양구	37.580726	126.776421	10.0	[37.580726, 126.776421]	1019653	벌말교	[37.583333333333336, 126.77222222222223]	2020-08-26 23:00:00	230.0	1239.0
7456999	7456999	굴포천교	인천광역시	계양구	37.580726	126.776421	10.0	[37.580726, 126.776421]	1019653	벌말교	[37.583333333333336, 126.77222222222223]	2020-08-27 00:00:00	238.0	1239.0
7457000	7457000	굴포천교	인천광역시	계양구	37.580726	126.776421	10.0	[37.580726, 126.776421]	1019653	벌말교	[37.583333333333336, 126.77222222222223]	2020-08-27 01:00:00	230.0	1239.0
7457001	7457001	굴포천교	인천광역시	계양구	37.580726	126.776421	10.0	[37.580726, 126.776421]	1019653	벌말교	[37.583333333333336, 126.77222222222223]	2020-08-27 02:00:00	237.0	1239.0